package com.financing.platform.dao;


import java.sql.SQLException;
import java.util.List;

import com.financing.platform.dto.FpFaUserDTO;
import com.financing.platform.dto.vo.FpFaUserVoDTO;
import com.financing.platform.vo.JcsYxtActivityVO;
import com.financing.platform.vo.UserAllSumVO;
import com.financing.platform.vo.UserShopRoleVO;
/**
 * fp_fa_user  
 * FA人员信息表 数据访问层接口
 * @author huqiyun
 *
 */
public interface IFpFaUserDao extends IBaseDao {

 	public int insert(FpFaUserDTO fpFaUser) throws SQLException;
    
    public void update(FpFaUserDTO fpFaUser) throws SQLException;
   
    public void updateForce(FpFaUserDTO fpFaUser) throws SQLException;
   
    public void delete(Integer id) throws SQLException;
	
    public List<FpFaUserDTO> queryList(FpFaUserDTO fpFaUser)throws SQLException;
    
    public int queryListCount(FpFaUserDTO fpFaUser) throws SQLException;
   
    public FpFaUserDTO loadById(Integer id) throws SQLException;
    
    public FpFaUserDTO queryByMobile(String mobile) throws SQLException;

	public int queryBySfaCount(FpFaUserDTO fpFaUser) throws SQLException;

	public List<FpFaUserVoDTO> queryBySfaTimeCount(FpFaUserDTO userDTO) throws SQLException;
	
	public List<FpFaUserVoDTO> queryByJcsCount(FpFaUserDTO userDTO) throws SQLException;

	public List<FpFaUserVoDTO> queryBySfaNowDayRole1(FpFaUserDTO userDTO) throws SQLException;

	public List<FpFaUserDTO> queryListByAuthDate(FpFaUserDTO user) throws SQLException;

	public List<JcsYxtActivityVO> queryActivityCount(FpFaUserDTO faUser) throws SQLException;

	public int queryAllByAuthDate(FpFaUserDTO user) throws SQLException;
  
	public int queryUserCount(FpFaUserDTO fpFaUserDTO)throws SQLException;

	public List<UserShopRoleVO> queryListCountByUshopRole(FpFaUserDTO userDTO)throws SQLException;

	public List<UserAllSumVO> queryBYAllSum(FpFaUserDTO uDTO) throws SQLException;
}